Select
  Transactions.BookDate As Boekdatum,
  Contract.Number As Rekening,
  Contract.Name As Rekeningnaam,
  Relation.Name As Relatienaam,
  Account.Number As Relatierekening,
  Transactions.Amount As Bedrag,
  MainCategory.Name As Hoofdrubriek,
  Category.Name As Rubriek,
  Transactions.Description As Omschrijving,
  Transactions.Remark As Opmerking
From
  Transactions Inner Join
  Contract On Transactions.ContractId = Contract.Id Left Join
  Relation On Transactions.RelationId = Relation.Id Left Join
  Account On Relation.AccountId = Account.Id Left Join
  Category On Transactions.CategoryId = Category.Id Left Join
  Category MainCategory On Transactions.MainCategoryId = MainCategory.Id
Where
  Transactions."Year" >= 2014 And
  Category.Name Is Null And
  Transactions.Description Not Like 'Kaartnummer%'
Order By
  Boekdatum
